
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Netsky-CellTree">
<style>
<!--
br.x_dml
	{mso-data-placement:same-cell;}
tr.x_dml
	{height:14.25pt;}
td.x_dml
	{
	padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	font-size:12.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	color:windowtext;
	font-family:宋体;
	text-align:general;
	vertical-align:middle;
	border:none;
	mso-number-format:"_ * \#\,\#\#0\.00_ \;_ * \\-\#\,\#\#0\.00_ \;_ * \0022-\0022??_ \;_ \@_ ";
	white-space:nowrap;}
.x_head1
	{
	height:14.25pt;
	width:80pt;
	font-size:9.0pt;
	text-align:left;
	border:.5pt solid windowtext;
	background:teal;}
.x_head2
	{
	height:14.25pt;
	width:80pt;
	font-size:9.0pt;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	background:teal;}
.x_head3
	{
	height:14.25pt;
	width:160pt;
	font-size:9.0pt;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	background:teal;}
.x_item1
	{
	height:14.25pt;
	font-size:9.0pt;
	text-align:left;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;}
.x_item2
	{
	font-size:9.0pt;
	text-align:left;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;}
.x_item3
	{
	font-size:9.0pt;
	text-align:left;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;}

	TABLE.x_hlist { FONT-SIZE: 12px; COLOR: #000000 } 
	.TitleLine { padding-left: 12px; FONT-WEIGHT:
	bold; FONT-SIZE: 12px; COLOR: #ffffff; background-color: #578b43; height:
	28px; padding-top:6px; } 
	.TitleLine2 { padding-left: 12px; FONT-WEIGHT:
	bold; FONT-SIZE: 12px; COLOR: #ffffff; background-color: #578b43; height:
	20px; padding-top:4px; } 
	.Titleline2_bg{ background-color:#f3f3ec; border-bottom:2px
	solid #578b43; padding:10px; } 
	.Titleline2td{ height:18px; } 
	.vt9_title
	{ font-weight: bold; font-size: 12px; color: #2F2F2F; background-color:
	#CCCCCC; height: 20px; line-height: 24px; } 
	.T9_blackB { FONT-WEIGHT: bold;
	FONT-SIZE: 12px; COLOR: #008000; LINE-height: 25px; TEXT-DECORATION: none;
	TEXT-align: left; background-color:#cecece; padding-left:5px; }
	.table_border td{border-top:1px #888 solid;border-right:1px #888 solid;padding-left:5px;}
	.table_border{border-bottom:1px #888 solid;border-left:1px #888 solid;}
-->
</style>
<!--[if gte mso 9]><xml>
 <x:ExcelWorkbook>
  <x:ExcelWorksheets>
   <x:ExcelWorksheet>
    <x:Name>Sheet1</x:Name>
    <x:WorksheetOptions>
     <x:Selected/>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
  </x:ExcelWorksheets>
 </x:ExcelWorkbook>
</xml>
<![endif]-->
</head>


<body link=blue vlink=purple>

<h1>demo_ch (数据库结构)</h1>
<p>
——CurUserName 2020/4/21
</p>

<h2>一、架构</h2>

<h3>1.1 模型8</h3>


<h4>1.1.1 admin (后台用户表)</h4>

<h4>1.1.2 admin_login_log (后台用户登录日志表)</h4>

<h4>1.1.3 admin_role_relation (后台用户和角色关系表)</h4>

<h4>1.1.4 menu (后台菜单表)</h4>

<h4>1.1.5 resource (后台资源表)</h4>

<h4>1.1.6 resource_menu_relation (后台资源(按钮)菜单关系表)</h4>

<h4>1.1.7 role (后台用户角色表)</h4>

<h4>1.1.8 role_menu_relation (后台角色菜单关系表)</h4>

<h4>1.1.9 role_resource_relation (后台角色资源关系表)</h4>

<p>模型图：</p>

<img src="" />




<h2>二、字典</h2>



<h3>2.1 模型8</h3>



<h4>2.1.1 admin (后台用户表)</h4>

<table class=x_dml x:str border=0 cellpadding=0 cellspacing=0
	style='border-collapse:collapse;table-layout:fixed;'>
<tr>
<td class=x_head1>字段名</td>
<td class=x_head2>逻辑名</td>
<td class=x_head2>数据类型</td>
<td class=x_head2>约束</td>
<td class=x_head3>说明</td>
</tr>

<tr>
<td class=x_item1>id</td>
<td class=x_item2></td>
<td class=x_item2>Integer</td>
<td class=x_item2>主键</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>login_phone</td>
<td class=x_item2>手机号</td>
<td class=x_item2>String(20)</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>username</td>
<td class=x_item2></td>
<td class=x_item2>String(64)</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>password</td>
<td class=x_item2></td>
<td class=x_item2>String(64)</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>icon</td>
<td class=x_item2>头像</td>
<td class=x_item2>String(500)</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>email</td>
<td class=x_item2>邮箱</td>
<td class=x_item2>String(100)</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>age</td>
<td class=x_item2></td>
<td class=x_item2>Enum</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>sex</td>
<td class=x_item2></td>
<td class=x_item2>Bool</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>nick_name</td>
<td class=x_item2>昵称</td>
<td class=x_item2>String(200)</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>note</td>
<td class=x_item2>备注信息</td>
<td class=x_item2>String(500)</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>login_time</td>
<td class=x_item2>最后登录时间</td>
<td class=x_item2>Date</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>status</td>
<td class=x_item2>帐号启用状态：0</td>
<td class=x_item2>Bool</td>
<td class=x_item2>非空,缺省值:1</td>
<td class=x_item3>帐号启用状态：0-&gt;禁用；1-&gt;启用</td>
</tr>


<tr>
<td class=x_item1>delete_status</td>
<td class=x_item2>删除状态</td>
<td class=x_item2>Integer</td>
<td class=x_item2>非空</td>
<td class=x_item3>删除状态 1未删除 0已删除</td>
</tr>


<tr>
<td class=x_item1>create_time</td>
<td class=x_item2>创建时间</td>
<td class=x_item2>Date</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>create_user</td>
<td class=x_item2>创建人</td>
<td class=x_item2>String(64)</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>create_user_id</td>
<td class=x_item2>创建人ID</td>
<td class=x_item2>Integer</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>update_time</td>
<td class=x_item2>更新时间</td>
<td class=x_item2>Date</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>update_user</td>
<td class=x_item2>更新人</td>
<td class=x_item2>String(64)</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>update_user_id</td>
<td class=x_item2>更新人ID</td>
<td class=x_item2>Integer</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


</table>



<h4>2.1.2 admin_login_log (后台用户登录日志表)</h4>

<table class=x_dml x:str border=0 cellpadding=0 cellspacing=0
	style='border-collapse:collapse;table-layout:fixed;'>
<tr>
<td class=x_head1>字段名</td>
<td class=x_head2>逻辑名</td>
<td class=x_head2>数据类型</td>
<td class=x_head2>约束</td>
<td class=x_head3>说明</td>
</tr>

<tr>
<td class=x_item1>id</td>
<td class=x_item2></td>
<td class=x_item2>Integer</td>
<td class=x_item2>主键</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>admin_id</td>
<td class=x_item2></td>
<td class=x_item2>Integer</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>ip</td>
<td class=x_item2></td>
<td class=x_item2>String(64)</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>address</td>
<td class=x_item2></td>
<td class=x_item2>String(100)</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>user_agent</td>
<td class=x_item2>浏览器登录类型</td>
<td class=x_item2>String(100)</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>delete_status</td>
<td class=x_item2>删除状态</td>
<td class=x_item2>Integer</td>
<td class=x_item2></td>
<td class=x_item3>删除状态 1未删除 0已删除</td>
</tr>


<tr>
<td class=x_item1>create_time</td>
<td class=x_item2>创建时间</td>
<td class=x_item2>Date</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>create_user</td>
<td class=x_item2>创建人</td>
<td class=x_item2>String(64)</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>create_user_id</td>
<td class=x_item2>创建人ID</td>
<td class=x_item2>Integer</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>update_time</td>
<td class=x_item2>更新时间</td>
<td class=x_item2>Date</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>update_user</td>
<td class=x_item2>更新人</td>
<td class=x_item2>String(64)</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>update_user_id</td>
<td class=x_item2>更新人ID</td>
<td class=x_item2>Integer</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


</table>



<h4>2.1.3 admin_role_relation (后台用户和角色关系表)</h4>

<table class=x_dml x:str border=0 cellpadding=0 cellspacing=0
	style='border-collapse:collapse;table-layout:fixed;'>
<tr>
<td class=x_head1>字段名</td>
<td class=x_head2>逻辑名</td>
<td class=x_head2>数据类型</td>
<td class=x_head2>约束</td>
<td class=x_head3>说明</td>
</tr>

<tr>
<td class=x_item1>id</td>
<td class=x_item2></td>
<td class=x_item2>Integer</td>
<td class=x_item2>主键</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>admin_id</td>
<td class=x_item2></td>
<td class=x_item2>Integer</td>
<td class=x_item2>外键,非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>role_id</td>
<td class=x_item2></td>
<td class=x_item2>Integer</td>
<td class=x_item2>外键,非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>delete_status</td>
<td class=x_item2>删除状态</td>
<td class=x_item2>Integer</td>
<td class=x_item2>非空</td>
<td class=x_item3>删除状态 1未删除 0已删除</td>
</tr>


<tr>
<td class=x_item1>create_time</td>
<td class=x_item2>创建时间</td>
<td class=x_item2>Date</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>create_user</td>
<td class=x_item2>创建人</td>
<td class=x_item2>String(64)</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>create_user_id</td>
<td class=x_item2>创建人ID</td>
<td class=x_item2>Integer</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>update_time</td>
<td class=x_item2>更新时间</td>
<td class=x_item2>Date</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>update_user</td>
<td class=x_item2>更新人</td>
<td class=x_item2>String(64)</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>update_user_id</td>
<td class=x_item2>更新人ID</td>
<td class=x_item2>Integer</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


</table>



<h4>2.1.4 menu (后台菜单表)</h4>

<table class=x_dml x:str border=0 cellpadding=0 cellspacing=0
	style='border-collapse:collapse;table-layout:fixed;'>
<tr>
<td class=x_head1>字段名</td>
<td class=x_head2>逻辑名</td>
<td class=x_head2>数据类型</td>
<td class=x_head2>约束</td>
<td class=x_head3>说明</td>
</tr>

<tr>
<td class=x_item1>id</td>
<td class=x_item2></td>
<td class=x_item2>Integer</td>
<td class=x_item2>主键</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>parent_id</td>
<td class=x_item2>父级ID</td>
<td class=x_item2>Integer</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>title</td>
<td class=x_item2>菜单名称</td>
<td class=x_item2>String(100)</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>level</td>
<td class=x_item2>菜单级数</td>
<td class=x_item2>Integer</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>sort</td>
<td class=x_item2>菜单排序</td>
<td class=x_item2>Integer</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>name</td>
<td class=x_item2>前端名称</td>
<td class=x_item2>String(100)</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>front_uri</td>
<td class=x_item2>前端资源路径</td>
<td class=x_item2>String(200)</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>icon</td>
<td class=x_item2>前端图标</td>
<td class=x_item2>String(200)</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>hidden</td>
<td class=x_item2>前端隐藏</td>
<td class=x_item2>Bool</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>delete_status</td>
<td class=x_item2>删除状态</td>
<td class=x_item2>Integer</td>
<td class=x_item2>非空</td>
<td class=x_item3>删除状态 1未删除 0已删除</td>
</tr>


<tr>
<td class=x_item1>create_time</td>
<td class=x_item2>创建时间</td>
<td class=x_item2>Date</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>create_user</td>
<td class=x_item2>创建人</td>
<td class=x_item2>String(64)</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>create_user_id</td>
<td class=x_item2>创建人ID</td>
<td class=x_item2>Integer</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>update_time</td>
<td class=x_item2>更新时间</td>
<td class=x_item2>Date</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>update_user</td>
<td class=x_item2>更新人</td>
<td class=x_item2>String(64)</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>update_user_id</td>
<td class=x_item2>更新人ID</td>
<td class=x_item2>Integer</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


</table>



<h4>2.1.5 resource (后台资源表)</h4>

<table class=x_dml x:str border=0 cellpadding=0 cellspacing=0
	style='border-collapse:collapse;table-layout:fixed;'>
<tr>
<td class=x_head1>字段名</td>
<td class=x_head2>逻辑名</td>
<td class=x_head2>数据类型</td>
<td class=x_head2>约束</td>
<td class=x_head3>说明</td>
</tr>

<tr>
<td class=x_item1>id</td>
<td class=x_item2></td>
<td class=x_item2>Integer</td>
<td class=x_item2>主键</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>name</td>
<td class=x_item2>名称</td>
<td class=x_item2>String(200)</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>url</td>
<td class=x_item2>资源URL</td>
<td class=x_item2>String(200)</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>description</td>
<td class=x_item2>描述</td>
<td class=x_item2>String(500)</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>icon</td>
<td class=x_item2>图标</td>
<td class=x_item2>String(500)</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>status</td>
<td class=x_item2>启用状态；0</td>
<td class=x_item2>Bool</td>
<td class=x_item2>非空</td>
<td class=x_item3>启用状态；0-&gt;禁用；1-&gt;启用</td>
</tr>


<tr>
<td class=x_item1>sort</td>
<td class=x_item2>排序</td>
<td class=x_item2>Integer</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>delete_status</td>
<td class=x_item2>删除状态</td>
<td class=x_item2>Integer</td>
<td class=x_item2>非空</td>
<td class=x_item3>删除状态 1未删除 0已删除</td>
</tr>


<tr>
<td class=x_item1>create_time</td>
<td class=x_item2>创建时间</td>
<td class=x_item2>Date</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>create_user</td>
<td class=x_item2>创建人</td>
<td class=x_item2>String(64)</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>create_user_id</td>
<td class=x_item2>创建人ID</td>
<td class=x_item2>Integer</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>update_time</td>
<td class=x_item2>更新时间</td>
<td class=x_item2>Date</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>update_user</td>
<td class=x_item2>更新人</td>
<td class=x_item2>String(64)</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>update_user_id</td>
<td class=x_item2>更新人ID</td>
<td class=x_item2>Integer</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


</table>



<h4>2.1.6 resource_menu_relation (后台资源(按钮)菜单关系表)</h4>

<table class=x_dml x:str border=0 cellpadding=0 cellspacing=0
	style='border-collapse:collapse;table-layout:fixed;'>
<tr>
<td class=x_head1>字段名</td>
<td class=x_head2>逻辑名</td>
<td class=x_head2>数据类型</td>
<td class=x_head2>约束</td>
<td class=x_head3>说明</td>
</tr>

<tr>
<td class=x_item1>id</td>
<td class=x_item2></td>
<td class=x_item2>Integer</td>
<td class=x_item2>主键</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>menu_id</td>
<td class=x_item2>菜单ID</td>
<td class=x_item2>Integer</td>
<td class=x_item2>外键,非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>resource_id</td>
<td class=x_item2>资源ID</td>
<td class=x_item2>Integer</td>
<td class=x_item2>外键,非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>delete_status</td>
<td class=x_item2>删除状态</td>
<td class=x_item2>Integer</td>
<td class=x_item2>非空</td>
<td class=x_item3>删除状态 1未删除 0已删除</td>
</tr>


<tr>
<td class=x_item1>create_time</td>
<td class=x_item2>创建时间</td>
<td class=x_item2>Date</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>create_user</td>
<td class=x_item2>创建人</td>
<td class=x_item2>String(64)</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>create_user_id</td>
<td class=x_item2>创建人ID</td>
<td class=x_item2>Integer</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>update_time</td>
<td class=x_item2>更新时间</td>
<td class=x_item2>Date</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>update_user</td>
<td class=x_item2>更新人</td>
<td class=x_item2>String(64)</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>update_user_id</td>
<td class=x_item2>更新人ID</td>
<td class=x_item2>Integer</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


</table>



<h4>2.1.7 role (后台用户角色表)</h4>

<table class=x_dml x:str border=0 cellpadding=0 cellspacing=0
	style='border-collapse:collapse;table-layout:fixed;'>
<tr>
<td class=x_head1>字段名</td>
<td class=x_head2>逻辑名</td>
<td class=x_head2>数据类型</td>
<td class=x_head2>约束</td>
<td class=x_head3>说明</td>
</tr>

<tr>
<td class=x_item1>id</td>
<td class=x_item2></td>
<td class=x_item2>Integer</td>
<td class=x_item2>主键</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>name</td>
<td class=x_item2>名称</td>
<td class=x_item2>String(100)</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>if_default</td>
<td class=x_item2>是否默认角色</td>
<td class=x_item2>Bool</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>description</td>
<td class=x_item2>描述</td>
<td class=x_item2>String(500)</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>admin_count</td>
<td class=x_item2>后台用户数量</td>
<td class=x_item2>Integer</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>status</td>
<td class=x_item2>启用状态：0</td>
<td class=x_item2>Bool</td>
<td class=x_item2>非空,缺省值:1</td>
<td class=x_item3>启用状态：0-&gt;禁用；1-&gt;启用</td>
</tr>


<tr>
<td class=x_item1>sort</td>
<td class=x_item2></td>
<td class=x_item2>Integer</td>
<td class=x_item2>缺省值:0</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>delete_status</td>
<td class=x_item2>删除状态</td>
<td class=x_item2>Integer</td>
<td class=x_item2>非空</td>
<td class=x_item3>删除状态 1未删除 0已删除</td>
</tr>


<tr>
<td class=x_item1>create_time</td>
<td class=x_item2>创建时间</td>
<td class=x_item2>Date</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>create_user</td>
<td class=x_item2>创建人</td>
<td class=x_item2>String(64)</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>create_user_id</td>
<td class=x_item2>创建人ID</td>
<td class=x_item2>Integer</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>update_time</td>
<td class=x_item2>更新时间</td>
<td class=x_item2>Date</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>update_user</td>
<td class=x_item2>更新人</td>
<td class=x_item2>String(64)</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>update_user_id</td>
<td class=x_item2>更新人ID</td>
<td class=x_item2>Integer</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


</table>



<h4>2.1.8 role_menu_relation (后台角色菜单关系表)</h4>

<table class=x_dml x:str border=0 cellpadding=0 cellspacing=0
	style='border-collapse:collapse;table-layout:fixed;'>
<tr>
<td class=x_head1>字段名</td>
<td class=x_head2>逻辑名</td>
<td class=x_head2>数据类型</td>
<td class=x_head2>约束</td>
<td class=x_head3>说明</td>
</tr>

<tr>
<td class=x_item1>id</td>
<td class=x_item2></td>
<td class=x_item2>Integer</td>
<td class=x_item2>主键</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>role_id</td>
<td class=x_item2>角色ID</td>
<td class=x_item2>Integer</td>
<td class=x_item2>外键,非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>menu_id</td>
<td class=x_item2>菜单ID</td>
<td class=x_item2>Integer</td>
<td class=x_item2>外键,非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>delete_status</td>
<td class=x_item2>删除状态</td>
<td class=x_item2>Integer</td>
<td class=x_item2>非空</td>
<td class=x_item3>删除状态 1未删除 0已删除</td>
</tr>


<tr>
<td class=x_item1>create_time</td>
<td class=x_item2>创建时间</td>
<td class=x_item2>Date</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>create_user</td>
<td class=x_item2>创建人</td>
<td class=x_item2>String(64)</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>create_user_id</td>
<td class=x_item2>创建人ID</td>
<td class=x_item2>Integer</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>update_time</td>
<td class=x_item2>更新时间</td>
<td class=x_item2>Date</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>update_user</td>
<td class=x_item2>更新人</td>
<td class=x_item2>String(64)</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>update_user_id</td>
<td class=x_item2>更新人ID</td>
<td class=x_item2>Integer</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


</table>



<h4>2.1.9 role_resource_relation (后台角色资源关系表)</h4>

<table class=x_dml x:str border=0 cellpadding=0 cellspacing=0
	style='border-collapse:collapse;table-layout:fixed;'>
<tr>
<td class=x_head1>字段名</td>
<td class=x_head2>逻辑名</td>
<td class=x_head2>数据类型</td>
<td class=x_head2>约束</td>
<td class=x_head3>说明</td>
</tr>

<tr>
<td class=x_item1>id</td>
<td class=x_item2></td>
<td class=x_item2>Integer</td>
<td class=x_item2>主键</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>role_id</td>
<td class=x_item2>角色ID</td>
<td class=x_item2>Integer</td>
<td class=x_item2>外键,非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>resource_id</td>
<td class=x_item2>资源ID</td>
<td class=x_item2>Integer</td>
<td class=x_item2>外键,非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>delete_status</td>
<td class=x_item2>删除状态</td>
<td class=x_item2>Integer</td>
<td class=x_item2>非空</td>
<td class=x_item3>删除状态 1未删除 0已删除</td>
</tr>


<tr>
<td class=x_item1>create_time</td>
<td class=x_item2>创建时间</td>
<td class=x_item2>Date</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>create_user</td>
<td class=x_item2>创建人</td>
<td class=x_item2>String(64)</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>create_user_id</td>
<td class=x_item2>创建人ID</td>
<td class=x_item2>Integer</td>
<td class=x_item2>非空</td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>update_time</td>
<td class=x_item2>更新时间</td>
<td class=x_item2>Date</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>update_user</td>
<td class=x_item2>更新人</td>
<td class=x_item2>String(64)</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


<tr>
<td class=x_item1>update_user_id</td>
<td class=x_item2>更新人ID</td>
<td class=x_item2>Integer</td>
<td class=x_item2></td>
<td class=x_item3></td>
</tr>


</table>



<h2>三、界面</h2>


<p>（略）</p>
<h2>四、代码</h2>

<p>（略）</p>


</body>
</html>

